UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ergjo9iASkJIXX5Bf6r47PStdA+WRo5NeWbpULEh+I4='
WHERE
key_id = '7d1aa573974b9131595b8139dad876798f55b115c8627e221178d7d23db9841e'
AND (
token = 'ergjo9iASkJIXX5Bf6r47PStdA+WRo5NeWbpULEh+I4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)