UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqjXzLUhnYFLqzcRy+VrczxTIhU5O3+c8Qw/B5s+zcg='
WHERE
key_id = '7c40f864fc5d9143537fa20a9ff1b615e7949a138dff51f118421c8cb4d2b301'
AND (
token = 'ZqjXzLUhnYFLqzcRy+VrczxTIhU5O3+c8Qw/B5s+zcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)