UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yW1w4NSl1E5c4CEVvYSxZ1jsaSXihrS/1J8Z/q14Nxc='
WHERE
key_id = '50bc5132713a630e62c829e4d99b53d568b7f1af035a1e56114a54e104b156ea'
AND (
token = 'yW1w4NSl1E5c4CEVvYSxZ1jsaSXihrS/1J8Z/q14Nxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)