UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZM3xCD/al4bepNbaD51rgzY87e4sHDlDV/gokT098U='
WHERE
key_id = '2a5abc67f972b4fda63a20fa7b7475d2f6b2d8267c2e3d71d1cdf9c08263d3dd'
AND (
token = 'XZM3xCD/al4bepNbaD51rgzY87e4sHDlDV/gokT098U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)