UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhD6pMF4AYjDoydVgZhR7xOeVhP+q9abJgNlNBSW8Bs='
WHERE
key_id = '59f5fff33d04201dabc61563ea965c30350c739327162c26f01f2612b45593b9'
AND (
token = 'qhD6pMF4AYjDoydVgZhR7xOeVhP+q9abJgNlNBSW8Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)