UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5tZt5rvxjdKxzm8eO3DifxfbSlNtfV5LwbVX11upUs='
WHERE
key_id = '2d99148b6d845fb4e7a2b1a0b7df8c4e28b05d5d03b60707fefa6f189502ed9e'
AND (
token = '/5tZt5rvxjdKxzm8eO3DifxfbSlNtfV5LwbVX11upUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)