UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KDjceW46oJPcDTFZXLsIoR3Pq4ADVd9WzfwNZ174WSs='
WHERE
key_id = '237813a1b67f768c6d1d22e8ba12e63549bcba5608a158cd7fcb9f7e1ef5177e'
AND (
token = 'KDjceW46oJPcDTFZXLsIoR3Pq4ADVd9WzfwNZ174WSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)