UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'goHtmIF/M/gpH9+kkrs9dnhAoIRMLSx+yegF1kU0+Fs='
WHERE
key_id = 'd0ac4b8e6526a02ca44bedb928d84778ed7e9ec28eaa9555d29a43b55c32f74b'
AND (
token = 'goHtmIF/M/gpH9+kkrs9dnhAoIRMLSx+yegF1kU0+Fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)