UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmP2SiZ3WKDBuDPL63a21/i83aZhHaD4rsgRaO+TlNY='
WHERE
key_id = '8a76a6caa681339bf4e49424171fed4aef4070489b4f3dbac5540f10133c97be'
AND (
token = 'VmP2SiZ3WKDBuDPL63a21/i83aZhHaD4rsgRaO+TlNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)