UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S/xhU3T8hrOmbfvNyC181vTlTPysj+flQGR9TfG+M6M='
WHERE
key_id = '18aa43f4edcb13e146a3a2d0b64ff97ebb8cb5ba3cb948bee9fb9d7d4b5fd617'
AND (
token = 'S/xhU3T8hrOmbfvNyC181vTlTPysj+flQGR9TfG+M6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)