UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/YZ596TORJAhmNIG5xmFW1MmvWRT5TNieC/UrKykS54='
WHERE
key_id = '57530d3d9a87a1b6ccfe8ba8e18e4d17b97df0d95f4adf57143a9a9ab860f775'
AND (
token = '/YZ596TORJAhmNIG5xmFW1MmvWRT5TNieC/UrKykS54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)